package com.monkeybrother.utils;

import org.apache.commons.lang3.StringUtils;

import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.net.ServerSocket;
import java.net.Socket;
import java.util.concurrent.TimeUnit;

/**
 * @Desc
 * @Author houry
 * @Date 2021/2/9 22:10
 **/
public class SocketClient {

    public static void main(String[] args) {
        StringBuilder sql = new StringBuilder();
        sql.append("select a.id activityId ")
                .append(",a.type type ")
                .append(",a.cover_url coverUrl ")
                .append(",a.title title ")
                .append(",a.start_time startTime ")
                .append(",a.end_time endTime ")
                .append(",a.address address ")
                .append(",a.people_limit peopleLimit ")
                .append(",a.content content ")
                .append(",am.signup_status signupStatus")
                .append(",a.status status")
                .append(",am.reject_reason rejectReason")
                .append(",am.org_name orgName")
                .append(",am.name")
                .append(",am.id_no idNo ")
                .append("from activity_members am ")
                .append("left join activity a ")
                .append("on am.activity_id = a.id ")
                .append("where a.del_flag = 0")
                .append(" and am.activity_id = ");
        System.out.println(sql.toString());
    }
}
